POSDepartmentHistory

Entity Definition

Logical Name : POSDepartmentHistory
Physical Name : LE_HST_PS_DPT

A collection of monetary and operational totals used to track open department sales that were made using a particular POSDepartment during a ReportingPeriod. Note: This entity does not summarize non-open department sales of Items that use the nominated POSDepartment for assigning default Item configuration settings. Such merchandise sales summaries are accumulated in MerchandiseHierarchySalesSummary.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer RetailStore(PA_STR_RTL)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
POSDepartmentID (FK)(PK) A unique system-assigned identifier for the POSDepartment ID_DPT_PS Identity integer POSDepartment(ID_DPT_PS)
LineItemVoidTotalAmount The total monetary amount of line item voids by POS department for each REPORTING PERIOD. CP_VD_LN_ITM_TOT Money decimal(16,5)
TotalLineItemVoidCount The total number of line item voids by POS department for each REPORTING PERIOD. QU_LTM_VD_TOT QuantityTransactionCount decimal(7,0)
PostTransactionVoidTotalAmount The total monetary amount of items cancelled by a post transaction void by POS department for each REPORTING PERIOD. CP_VD_PST_TRN_TOT Money decimal(16,5)
TotalPostTransactionVoidCount The total number of items cancelled by a post transaction void by POS department for each REPORTING PERIOD. QU_VD_PST_TRN_TOT QuantityTransactionCount decimal(7,0)
TransactionVoidTotalAmount The total monetary amount of items cancelled by transaction void by POS department for each REPORTING PERIOD. CP_VD_TRN_TOT Money decimal(16,5)
TotalTranactionVoidCount The total number of items cancelled by transaction void by POS department for each REPORTING PERIOD. QU_VD_TRN_TOT QuantityTransactionCount decimal(7,0)
ReturnTotalAmount The total monetary amount of returns by POS department for each REPORTING PERIOD. CP_RTN_TOT Money decimal(16,5)
TotalReturnCount The total number of returns by POS department for each REPORTING PERIOD. QU_RTN_TOT QuantityTransactionCount decimal(7,0)
RefundTotalAmount The total monetary amount of refunds by POS department for each REPORTING PERIOD. CP_RFD_TOT Money decimal(16,5)
TotalRefundCount The total number of refunds by POS department for each REPORTING PERIOD. QU_RFD_TOT QuantityTransactionCount decimal(7,0)
EmployeeDiscountTotalAmount The total monetary amount of employee discounts by POS department for each REPORTING PERIOD. CP_DSC_EM_TOT Money decimal(16,5)
TotalEmployeeDiscountCount The total number of employee discounted items by POS department for each REPORTING PERIOD. QU_DSC_EM_TOT QuantityTransactionCount decimal(7,0)
MiscellaneousDiscountTotalAmount The total monetary amount of miscellaneous discounts by POS department for each REPORTING PERIOD. CP_DSC_MSC_TOT Money decimal(16,5)
TotalMiscellaneousDiscountCount The total number of miscellaneous discounted items by POS department for each REPORTING PERIOD. QU_DSC_MSC_TOT QuantityTransactionCount decimal(7,0)
StoreCouponTotalAmount The total monetary amount of lines purchased in part or in full by store coupons by POS department for each REPORTING PERIOD. CP_CPN_STR_TOT Money decimal(16,5)
TotalStoreCouponCount he total number of lines purchased in part or in full by store coupons by POS department for each REPORTING PERIOD. QU_CPN_STR_TOT QuantityTransactionCount decimal(7,0)
RedeemedContainerDepositTotalAmount The total monetary amount of redeemed container deposits by POS department for each REPORTING PERIOD. CP_DS_RDM_CNR_TOT Money decimal(16,5)
TotalRedeemedContainerDepositCount he total number of redeemed container deposits by POS department for each REPORTING PERIOD. QU_DS_RDM_CNR_TOT QuantityTransactionCount decimal(7,0)
MarkdownTotalAmount The total monetary amount of markdowns by POS department for each REPORTING PERIOD. CP_MKD_TOT Money decimal(16,5)
TotalMarkdownCount The total number of markdowns by POS department for each REPORTING PERIOD. QU_MKD_TOT QuantityTransactionCount decimal(7,0)
NetItemSalesTotalAmount The total monetary amount of net item sales by POS department for each REPORTING PERIOD. CP_SLS_NT_ITM_TOT Money decimal(16,5)
MiscellaneousFeeTotalAmount The total monetary amount of miscellaneous fees by POS department for each REPORTING PERIOD. CP_FE_MSC_TOT Money decimal(16,5)
TotalMiscellaneousFeeCount The total number of miscellaneous fees by POS department for each REPORTING PERIOD. QU_FE_MSC_TOT QuantityTransactionCount decimal(7,0)
ContainerDepositTotalAmount The total monetary amount of container deposits by POS department for each REPORTING PERIOD. CP_DS_CNR_TOT Money decimal(16,5)
TotalContainerDepositCount The total number of container deposits by POS department for each REPORTING PERIOD. QU_DS_CNR_TOT QuantityTransactionCount decimal(7,0)
TaxTotalAmount The total monetary amount of tax item sales by POS department for each REPORTING PERIOD. CP_TX_TOT Money decimal(16,5)
TaxExemptTotalAmount The total monetary amount of tax exempt item sales by POS department for each REPORTING PERIOD. CP_TX_EXM_TOT Money decimal(16,5)
TotalTaxExemptTransactionCount The total number of tax exempt item sales by POS department for each REPORTING PERIOD. QU_TRN_TX_EXM QuantityTransactionCount decimal(7,0)
TotalLineItemOverrideCount The total number of line item overrides by POS department for each REPORTING PERIOD. QU_LTM_OVRD_TOT QuantityTransactionCount decimal(7,0)
TotalWeighedLineItemCount The total number of weighed item sales by POS department for each REPORTING PERIOD. QU_ITM_LN_WT_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemKeyedCount The total number of keyed item sales by POS department for each REPORTING PERIOD. QU_LTM_KY_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemScannedCount The total number of scanned item sales by POS department for each REPORTING PERIOD. QU_LTM_SC_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemKeyedPercentage The number of items keyed as a percentage of total items sold by POS department for each REPORTING PERIOD. PE_LTM_KY_TOT Percent decimal(7,4)
TotalLineItemScannedPercentage The number of items scanned as a percentage of total items sold by POS department for each REPORTING PERIOD. PE_LTM_SC_TOT Percent decimal(7,4)
TotalLineItemOpenDepartmentCount The total number of items sold by a POS department for each REPORTING PERIOD. QU_LTM_DPT_TOT QuantityTransactionCount decimal(7,0)
TotalLineItemOpenDepartmentPercentage The number of items sold through a department key as a percentage of total items sold by POS department for each REPORTING PERIOD. PE_LTM_DPT_TOT Percent decimal(7,4)
TotalSaleLineItemCount The total number of item sales by POS department for each REPORTING PERIOD. QU_LTM_SLS_TOT QuantityTransactionCount decimal(7,0)

Relationships

Parent Entity Verb Phrase Child Entity
ReportingPeriod delineates POSDepartmentHistory
POSDepartment is tracked via POSDepartmentHistory
RetailStore delineates POSDepartmentHistory

Logical Views containing POSDepartmentHistory

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 10300 - Enterprise - POS Department View